interview

Home / DeveloperSection / Interviews / How to find the difference between two given dates in SQL Server?

Ask Question
Ashutosh Kumar Verma

Ashutosh Kumar Verma

Follow
Myself Ashutosh Kumar Verma from Varanasi. I am a Software Developer in MindStick Software pvt. ltd. Prayagraj. I have completed my MCA from VBSP. University, Jaunpur in 2021.

Can you answer this question?

Answer

2 Answers

Aryan Kumar

Aryan Kumar

20-Jun-2023

To find the difference between two given dates in SQL Server, you can use the DATEDIFF() function. The DATEDIFF() function takes three arguments:

  • The first argument is the datepart, which specifies the unit of time that you want to measure the difference in. For example, you can use day, month, year, hour, minute, or second.
  • The second argument is the start date.
  • The third argument is the end date.

The DATEDIFF() function returns the difference between the two dates in the specified unit of time. For example, the following query will return the difference between the dates '2023-01-01' and '2023-01-15' in days:

SQL

SELECT DATEDIFF(day, '2023-01-01', '2023-01-15');

This query will return the value 14, which means that there are 14 days between the two dates.

Here is the syntax for the DATEDIFF() function:

SQL

DATEDIFF ( datepart, start_date, end_date )
  • datepart is the datepart that you want to measure the difference in.
  • start_date is the start date.
  • end_date is the end date.

The DATEDIFF() function can also be used to find the difference between two datetimes. For example, the following query will return the difference between the datetimes '2023-01-01 12:00:00' and '2023-01-15 12:00:00' in hours:

SQL

SELECT DATEDIFF(hour, '2023-01-01 12:00:00', '2023-01-15 12:00:00');

This query will return the value 336, which means that there are 336 hours between the two datetimes.

Ashutosh Kumar Verma

Ashutosh Kumar Verma

22-Nov-2021

DATEDIFF():

    SQL DATEDIFF() function is used to find the difference between two given dates in term of year, month or day.

Example:    

Find the different between two date in Year.

    SELECT DATEDIFF(YEAR,'2011/12/15','2013/05/25');

 Output:         2

      Find the different between two date in Month.

SELECT DATEDIFF(MONTH,'2011/12/15','2013/05/25');

Output:     17

Find the different between two date in Day.

SELECT DATEDIFF(DAY,'2011/12/15','2013/05/25');

Output:    527

Liked By